Mark Cronk
Mark Cronk
Reactions
-
Re: COUNTIFS not working correctly
Hi @aschneiderheinze74206 , Try =COUNTIFS([Project Type]:[Project Type], "Maintenance", [Revision Status]:[Revision Status], <>"Canceled", [Term Submitted]:[Term Submitted],…1 · -
Re: Automated Workflow - Alert Notifications
Hi @Edwina Sampler-Wright , There isn't a record of alerts like there are for update requests, which are attached to the row. Alerts aren't recorded in the activity log either. The only workaround I …2 · -
Re: Is there a way to populate a dropdown list from another sheet?
Hi @Justin Mauzy , Unfortunately Smartsheet doesn't currently have the ability to create dynamic drop down options. I believe there are some 3rd party add on that will but I've never tried them. Some…1 · -
Re: Milestones
Hi @smartsheets1 , I don't think you can create a multi-day milestone. You can have it fill 1 day by using a duration of ~0. See article below. You can also add a milestone task (start date with 0 du…1 · -
Re: Project health using DELTA
Hi @Tom Lombard , Target Start-End are your planned dates. Start-End are actuals. The delta is the difference between planned and actual in % and working days. Help? Mark1 ·
